package com.zood.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zood.domain.show;
import com.zood.domain.stone;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ShowDao extends BaseMapper<show> {
    @Select("select count(id) from t_activity ")
    int getCount();

    @Select("SELECT * FROM t_show WHERE amid=smid && smid=#{id}")
    List<show> getAllById(@Param("id") int id);

    @Select("SELECT * FROM t_show WHERE asid=sid && smid=#{mid} && stid=#{tid}")
    List<show> getAllById1( int mid,int tid);

    @Select("select count(*) from t_show ")
    int getShowCount();

}
